<?php
class Request_model extends MY_Model{
	public $table = 'request';
	public $select = "request.tbknowledge_id,
tbknowledge.title kntitle,
request.id,
request.req_user_id,
request.own_user_id,
request.`status`,
request.created,
tbknowledgetype.title typetitle,
req_user.name as req_username,
own_user.name as own_username";
	public $join = 'left Join tbknowledge ON tbknowledge.id = request.tbknowledge_id
left Join tbknowledgetype ON tbknowledgetype.id = tbknowledge.knowledgetypeid
Left Join users as req_user ON request.req_user_id = req_user.id
Left Join users as own_user ON request.own_user_id = own_user.id';
	
	function __construct()
	{
		parent:: __construct();
	}
}
?>